When reading numeric data into SAS^®, it is often helpful to assign characters in your input data to represent special missing values for numeric data. The MISSING statement specifies the value in your input data that represents a special missing value. This can be any of the letters of the alphabet or the underscore character.

The ANYDTDTE, ANYDTDTM, and ANYDTTME informats do not read the special missing values correctly. Instead of showing the letter or underscore from the input data in the output, a period is shown instead.

To circumvent the problem, use a different informat to read the input data that contains special missing values.

The sample code on the Full Code tab illustrates the problem and a circumvention.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	HP-UX IPF	9.3 TS1M0	9.4 TS1M5
		64-bit Enabled Solaris	9.3 TS1M0	9.4 TS1M5
		64-bit Enabled HP-UX	9.3 TS1M0	9.4 TS1M5
		64-bit Enabled AIX	9.3 TS1M0	9.4 TS1M5
		Windows Vista for x64	9.3 TS1M0
		Windows Vista	9.3 TS1M0
		Windows 7 Ultimate x64	9.3 TS1M0	9.4 TS1M5
		Windows 7 Ultimate 32 bit	9.3 TS1M0	9.4 TS1M5
		Windows 7 Professional x64	9.3 TS1M0	9.4 TS1M5
		Windows 7 Professional 32 bit	9.3 TS1M0	9.4 TS1M5
		Windows 7 Home Premium x64	9.3 TS1M0	9.4 TS1M5
		Windows 7 Home Premium 32 bit	9.3 TS1M0	9.4 TS1M5
		Windows 7 Enterprise x64	9.3 TS1M0	9.4 TS1M5
		Windows 7 Enterprise 32 bit	9.3 TS1M0	9.4 TS1M5
		Microsoft Windows XP Professional	9.3 TS1M0
		Microsoft Windows Server 2008 for x64	9.3 TS1M0
		Microsoft Windows Server 2008 R2	9.3 TS1M0
		Microsoft Windows Server 2008	9.3 TS1M0
		Microsoft Windows Server 2003 for x64	9.3 TS1M0
		Microsoft Windows Server 2003 Standard Edition	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise Edition	9.3 TS1M0
		Microsoft Windows Server 2003 Datacenter Edition	9.3 TS1M0
		Microsoft® Windows® for x64	9.3 TS1M0	9.4 TS1M5
		z/OS 64-bit	9.3 TS1M0	9.4 TS1M5
		z/OS	9.3 TS1M0	9.4 TS1M5
		Linux	9.3 TS1M0	9.4 TS1M5
		Linux for x64	9.3 TS1M0	9.4 TS1M5
		Solaris for x64	9.3 TS1M0	9.4 TS1M5

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

The ANYDTDTE informat does not handle special missing values correctly. In the sample code below, the DATE informat correctly displays 'A' for the value of X, whereas Y displays a period.

---

data _null_;
   missing A;
/* The DATE informat handles special missing values correctly */
   x=input('A',date.);
   put x=;

/* The ANYDTDTE informat does not handle missing values correctly */
   y=input('A',anydtdte.);
   put y=;
run;

Type:	Problem Note
Priority:	medium
Topic:	SAS Reference ==> Informats ==> Date and Time ==> ANYDTDTE SAS Reference ==> Informats ==> Date and Time ==> ANYDTDTM SAS Reference ==> Informats ==> Date and Time ==> ANYDTTME

Date Modified:	2016-09-20 15:49:44
Date Created:	2016-09-14 10:54:14